from lib.conn_sql_util import SQLUtil


def SQL():
    executesql = SQLUtil()
    sql = (
        "insert into rpt_revenue_overview(year,identity,grade,teacher_id,subject_id,jzzys,xszys,xkzys,pczxxs_i,pckkxs_i,pczxxs_o,pckkxs_o,b2cxs,xkxss,xkkjs) values "
        "(2025,4,7,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        "(2025,4,7,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        "(2025,4,7,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,8,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,8,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,8,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,9,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,9,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,9,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,12,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,12,3367,4,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,1,12,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,2,7,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,2,7,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,2,7,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,3,7,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,3,7,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,3,7,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,4,7,3367,2,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,4,7,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,4,7,3367,3,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,5,7,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,5,8,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        # "(2025,5,12,3367,10,12323,3333,111,444,555,111,333,122,4,88),"
        "(2025,4,9,3367,10,12323,3333,111,444,555,111,333,122,4,88);")

    # sql = "select * from mb_member where member_id = '202301310148535499'"
    print(executesql.executeSQL(sql))


